45. 练习：OR

使用 OR 运算符的问题

  1. 查找 orders 表，其中 gloss_qty （铜版纸数量） 或 poster_qty （海报纸数量）大于 4000。只在结果表中包含 id 字段。

  2. 查找 orders 表，其中普通纸数量 ( standard_qty )为零，铜版纸数量 ( gloss_qty ) 或海报数量 ( poster_qty )超过 1000，返回相关订单的所有信息。

  3. 查找 accounts 表，返回符合条件的信息：name 以 'C' 或 'W' 开头，主要联系人 ( primary contact ) 包含 'ana' 或 'Ana'，但不包含 'eana'。

Workspace

This section contains either a workspace (it can be a Jupyter Notebook workspace or an online code editor work space, etc.) and it cannot be automatically downloaded to be generated here. Please access the classroom with your account and manually download the workspace to your local machine. Note that for some courses, Udacity upload the workspace files onto https://github.com/udacity , so you may be able to download them there.

Workspace Information:

  • Default file path:
  • Workspace type: sql-evaluator
  • Opened files (when workspace is loaded): n/a

Next Concept